AS

The AS operator changes a column heading in a table during a SELECT command. This is very useful in reports.

El operador AS permite cambiar el nombre del encabezado de una tabla en un comando SELECT. Esto es extremadamente útil en los reportes.

SQL

-- Motorola database
SELECT first_name, last_name
FROM employee

SQL

-- Motorola database
SELECT first_name AS 'First Name', last_name AS 'Last Name'
FROM employee

Problem 1

ford > Write an SQL script to create and populate the ford database using: (a) Microsoft SQL Server, (b) Oracle, (c) MySQL.

Escriba un script de SQL para crear y llenar la base de datos ford usando (a) Microsoft SQL Server, (b) Oracle, (c) MySQL.